﻿#	SQL text for building Data Base for Test

# Host     : localhost
# User     : root
# Password : ..... (You need to use the good administrative password for your Me SQL
# Port     : 3306
# Database : Book_Test

DROP DATABASE IF EXISTS `book_new`;

CREATE DATABASE `book_test`
    CHARACTER SET 'utf8'
    COLLATE 'utf8_general_ci';

USE `book_test`;


#
# Structure for the `authors` table: 
#

CREATE TABLE `authors` (
  `AuthorNbr` SMALLINT(6) NOT NULL AUTO_INCREMENT,
  `AuthorName` VARCHAR(20) COLLATE utf8_general_ci DEFAULT NULL,
  `FirstName` VARCHAR(16) COLLATE utf8_general_ci DEFAULT NULL,
  `Comment` VARCHAR(40) COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY USING BTREE (`AuthorNbr`)
)ENGINE=InnoDB
AUTO_INCREMENT=0 CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';

#
# Data for the `authors` table  
#

INSERT INTO `authors` (`AuthorNbr`, `AuthorName`, `FirstName`, `Comment`) VALUES

  (1,'Арагон','Луи',''),
  (2,'Арним','Ахен',''),
  (3,'Бальзак','Оноре',''),
  (4,'Блек','Rene',''),
  (5,'Вагнер','Рихард',''),
  (6,'Вайскопф','Петер',''),
  (7,'Вринг','Георг',''),
  (8,'Гауф','Эрнст','');


